package com.example.lianguisystem.mapperLianGui;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.lianguisystem.entity.SalesOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface SalesOrderMapper extends BaseMapper<SalesOrder> {
    List<Map<String,Object>> listOfWorkshop(@Param("username") String username);
    List<Map<String,Object>> listOfNewWorkshop(@Param("username") String username);


    Map<String, Object> selectPriceByProd(@Param("unitid") Integer unitid, @Param("date") String date
            , @Param("storeid") Integer storeid, @Param("goodsid") Integer goodsid, @Param("traderid") Integer traderid
            , @Param("moneyid") Integer moneyid, @Param("shopid") Integer shopid);

    List<Map<String, Object>> selectGoodsBomPrices(@Param("masterGoodsId") Integer masterGoodsId);

    String selectMnfWorkshopById(@Param("workshopid") Integer workshopid);

    List<Map<String, Object>> listOfGoodsSelection(@Param("cpTypeNo") String cpTypeNo);

    SalesOrder selectById(@Param("id") String id);

    List<SalesOrder> listSalesOrder(@Param("recordDate") String recordDate,@Param("client") String client);


    String selectQrcodeDataById(@Param("id") String id);

    List<Map<String, Integer>> selectMmBillidByMmBillcode(@Param("billcode") String billcode);

    SalesOrder selectSalesOrderByBillCode(@Param("billcode") String billcode);

    String selectIdByBillid(@Param("orderBillId") Integer orderBillId);
}
